

/****** Object:  StoredProcedure [dbo].[SFDA_X_updateMessageReadStatus]    Script Date: 07/27/2013 18:19:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[SFDA_X_updateMessageReadStatus]
	@itemID NVARCHAR(50)='', @itemType NVARCHAR(50)='', @applicationType NVARCHAR(50)='', @userName NVARCHAR(50)=''
AS
SET NOCOUNT ON;

UPDATE T_realtimeMessaging SET isRead='readed' WHERE itemID=@itemID AND itemType=@itemType AND applicationType=@applicationType AND sendUser=@userName

SELECT 'FETCH'
GO

